| Author |
Thread Statistics | Show CCP posts - 6 post(s) |
|
CCP Spectrum
   |
Posted - 2008.11.28 09:25:00 -
[1]
Edited by: CCP Spectrum on 28/11/2008 09:27:50
Edited by: CCP Spectrum on 28/11/2008 09:25:56
 Originally by: Chribba
edit/I'm curious, this news post states the first Orca was completed November 14th at 07:43, by the Brotherhood of Sparta Corporation. The devblog states November 15 at 17:07... which one is correct? Is the news post based upon player facts or actual DB completion facts? Sparta lying?
Linkage 
I ran all the queries for this so I can answer that. :)
Basically, without giving away any super db secrets, there's a production log available to me for every production. From that log the date '2008-11-15 17:07' is the one logged as the minimum value for ending a production when filtering on the Orca explicitly. I can also add as a fun note that the next finished Orca production didn't finish until roughly 2 and a half hours later and then not another one until much later in the night. My answer for all data related issues has always been that databases never lie....unless correct data isn't put in there. I have no reason whatsoever to believe that the latter is the case (especially since the first market transaction including the Orca doesn't happen until many hours later) :)
|
|
|
CCP Spectrum
|
Posted - 2008.11.28 15:16:00 -
[2]
Edited by: CCP Spectrum on 28/11/2008 15:16:50
Originally by: Chribba
If that is the case then @ CCP Spectrum, did you use the value of "delivered" rather than "completed" in your DB query? Altho imo it should be the same value, at least if you go by the API exports - 'endProductionTime' is the same no matter if you have delivered the job or not.
I used the value when it was delivered, since that is defined as being a completed production in the db. the API export column 'endProductionTime' for the same row shows the date '2008-11-15 15:35:00' and is also the minimum value for that field filtered explicitly on the Orca. There is a difference of only 92 minutes between these two values and I can see how it's debatable which one is used. My sources pointed out that using the "completed" (delivered) date was more correct so I went with that. I hope this explanation is clear :)
|
|
|
CCP Spectrum
|
Posted - 2008.11.29 01:26:00 -
[3]
Edited by: CCP Spectrum on 29/11/2008 01:32:08
Edited by: CCP Spectrum on 29/11/2008 01:27:54
Edited by: CCP Spectrum on 29/11/2008 01:26:30
Jason: Good point regarding the production vs. research. I will most definitely look into it after the weekend. If I find something interesting I will be posting it as an addendum to the dev blog here in this thread. If not then I didn't find something 
Kweel: Of course, a very valid point. Bad queries are always an option. Over confidence is never good when doing db stuff. I've learned over time that double checking and testing works better than being over confident.
Thanks for all the comments. Some of them help us think outside of our box and I love how EVE players are smart like that. Regarding my name...it is of course related to my first love...the Sinclair Spectrum 48K. Atic Atac FTW!
Edit: Chribba: Yes, you are understanding it correctly.
|
|
|
CCP Spectrum
|
Posted - 2008.12.01 14:37:00 -
[4]
Originally by: Bartholomeus Crane
Ehhh, OK, any idea when we can expect QEN Q3?
To quote Eyjo from this thread: http://oldforums.eveonline.com/?a=topic&threadID=898939&page=2
"We plan on reporting more on the T2 market and T2 production in QEN Q3 2008(due in December) and QEN Q4 2008 (due in January 2009)."
Best Regards,
Spectrum :-)
|
|
| |
|